============================================================================== Simba Teradata ODBC Data Connector Release Notes ============================================================================== The release notes provide details of enhancements, features, known issues, and workflow changes in Simba Teradata ODBC Connector 20.00.00.028, as well as the version history. This version of the driver supports the following data source versions and platforms(Note: Platforms included with a distribution may vary according to what has been licensed): * Data source versions 16.20 and later. * Windows 11, 10, 8.1 or 7SP1, Windows Server 2022, 2016, 2012R2, 2012 or 2008 R2 SP1 * macOS 10.14, 10.15, 11 or 12 * Linux: RHEL 6, 7, 8, 8.5 or 9, CentOS 6, 7 or 8, SLES 11, 12 or 15, Ubuntu 16.04, 18.04, 20.04 or 22.04, Oracle Enterprise Linux 8, AIX 7.1 or 7.2, Solaris Sparc 11.3, Solaris Opteron 11.3 20.00.00.028 ================================================================= Released 2025-07-29 Resolved Issues The following issues have been resolved in Simba Teradata ODBC Connector 20.00.00.028. * [SENTDO-3043] When the user selects ClientTdHostName on logonoffv, the connector returns only the IP address, without the port number. * [SENTDO-3052] The connector fails to display Chinese characters in Teradata SQL Assistant. * [SENTDO-3059] When SSL Mode is set to 'Require', SQL Assistant and other GUI-based login applications experience login failures. * [SENTDO-3064] When the username or password is incorrect, the connector does not immediately return an error; instead, it waits until the connection attempt times out. Known Issues The following are known issues that you may encounter due to limitations in the data source, the connector, or an application. * [SENTDO-73] Statement info parcel returns errors for TIME parameters. When using statement info parcel and stored procedures with a TIME parameter are called, the connector returns an error. * Some custom fields are not supported for SQLGetDescField. When calling SQLGetDescField, the connector does not support the SQL_DESC_TD_ACTIVITY_TYPE and SQL_DESC_TD_COST_ESTIMATE custom header description fields. * Catalog functions always return ODBC 3.x column names. For catalog functions, the connector returns the ODBC 3.x column names rather than ODBC 2.x column names, even in an ODBC 2.x environment. * The setting for the SQL_ATTR_ROWS_FETCHED_PTR statement attribute does not persist. You can set a value by calling SQLSetStmtAttr(SQL_ATTR_ROWS_FETCHED_PTR), but the value is reset after you close the cursor. * In specific cases, during INSERT operations that require the data to be truncated, there is no message indicating that truncation has occurred. This behavior occurs when both of the following conditions are met: - The Session Mode option (the SessionMode property) is set to Teradata. - The connector inserts data that is too large for the target column. The database truncates the data to fit, but the message indicating that truncation has occurred is not returned. The connector expects the database to report the truncation. However, when Session Mode is set to Teradata, the database does not return the truncation message. Workflow Changes ============================================================= The following changes may disrupt established workflows for the connector. 20.00.00.003 ----------------------------------------------------------------- * [SENTDO-2717] Updated default login timeout The new default login timeout is 60 seconds. Previously, it was 20 seconds. Version History ============================================================== 20.00.00.026 ----------------------------------------------------------------- Released 2025-07-25 Resolved Issues The following issues have been resolved in Simba Teradata ODBC Connector 20.00.00.026. * [SENTDO-3038] Long connection latency. * [SENTDO-3049] LibCurl does not support Secure Transport on TLS 1.3. * [SENTDO-3051] Username, or UID, not allowed when using TD2 mechanism in multiple threads. 20.00.00.022 ----------------------------------------------------------------- Released 2025-04-25 Enhancements & New Features * [SENTDO-2887] Multiple Identities support The connector now supports multiple identities OIDC_LOGIN_HINT, OIDC_PROMPT, and OIDC_TOKEN_CACHE in the token memory cache. For more information, see the Installation and Configuration Guide. Resolved Issues The following issue has been resolved in Simba Teradata ODBC Connector 20.00.00.022. * [SENTDO-2983] When TLS sockets fail, the connector does not catch the SIGPIPE signal to prevent the application from crashing. This issue is resolved by the connector; however, if the application prefers to handle this signal, it can set the TD_NO_SIGPIPE_CATCH environment variable. 20.00.00.021 ----------------------------------------------------------------- Released 2025-02-25 Enhancements & New Features * [SENTDO-2918] Enhanced proxy server Windows support On Windows, the connector can now read from HTTP_PROXY, HTTPS_PROXY, and ALL_PROXY settings based on URI protocol. If URI protocol is:http://, HTTP_PROXY is used, if URI protocol is https://, HTTPS_PROXY is used, if both are unavailable, ALL_PROXY is used. For more information, see the Installation and Configuration Guide. Resolved Issues The following issue has been resolved in Simba Teradata ODBC Connector 20.00.00.021. * [SENTDO-2803] When SSLMode is set to Allow and both TDMST and HTTPS ports are available, the connector uses the HTTPS port instead of returning an error message. 20.00.00.019 ----------------------------------------------------------------- Released 2025-01-22 Enhancements & New Features * [SENTDO-2886] OIDC Token Memory Cache support The connector can now reuse credentials and log in multiple times for short-lived connections without refreshing tokens. To do this, set the Disable Token Cache checkbox to No. For more information, see the Installation and Configuration Guide. * [SENTDO-2946] Enhanced data encryption support You can now update the data encryption value from the connection string key UseDataEncryption to ClientAttributeEx in the database. For more information, see the Installation and Configuration Guide. Resolved Issues The following issues have been resolved in Simba Teradata ODBC Connector 20.00.00.019. * [SENTDO-2879] In some cases, when using the EXTERNALBROWSER mechanism, the connector does not connect because a socket operation is blocking it. * [SENTDO-2934] If the SSO Browser window is cancelled or closed before connecting to the database, the connector hangs. * [SENTDO-2958] When SSLCRC is set to Require and either the OCSP certificate or the OCSP URI is unknown, the connection does not return to CRL. 20.00.00.018 ----------------------------------------------------------------- Released 2024-12-26 Resolved Issues The following issues have been resolved in Simba Teradata ODBC Connector 20.00.00.018. * [SENTDO-2916] When binding data using SQL_C_WCHAR and setting the LC_ALL environment variable to 'C', the connector fails to return the data in UTF-8 format to the application. * [SENTDO-2941] The PERIOD(TIME(n)) does not get inserted when the DecimalDigits of SQLBindParameter is incorrect. * [SENTDO-2944] In the gateway session information, the certificate status is not updated. * [SENTDO-2945] When running a SELECT query with parameters, if the database does not figure out the type of an integral column (like INT or BIGINT), the connector wrongly assumes it is unsigned, causing a 'numeric value out of range' error. * [SENTDO-2949] The revocation function fails to check revocation because the revocation server is offline. * [SENTDO-2950] When the OCSP URI is missing in the database certificate, the connector continues to make OCSP requests. * [SENTDO-2951] When the username and password fields in the ODBC Administrator's DSN are empty, SQLA terminates unexpectedly. 20.00.00.012 ----------------------------------------------------------------- Released 2024-09-20 Resolved Issues The following issues have been resolved in Simba Teradata ODBC Connector 20.00.00.012. * [SENTDO-2876] The 'abort' button in SQL Assistant does not terminate the query. * [SENTDO-2899] When converting time, the connector converts the hour, minute, and second, but not the fractions of a second. 20.00.00.009 ----------------------------------------------------------------- Released 2024 Enhancements & New Features * [SENTDO-2847] Enhanced TTU FIPS module The connector uses the OpenSSL FIPS Provider module to make connections if the environment TTU_FIPS_ENABLE is set to the value "1". Resolved Issues The following issues have been resolved in Simba Teradata ODBC Connector 20.00.00.009. * [SENTDO-2870] The connector does not properly update the password in the OutConnectionString return value of a SQLDriverConnect() call when the password has expired in the database, or an administrator has forced a password change. * [SENTDO-2878] In the DSN Setup in ODBC Data Source Administrator of Windows, the Mechanism Options button is partially obscured if the pointer hovers over "Use Integrated Security". 20.00.00.008 ----------------------------------------------------------------- Released 2024-05-24 Enhancements & New Features * [SENTDO-2816] Client Credentials authentication You can now authenticate your connection with Client Credentials, also known as Bearer Flow. To do this, from the Mechanism drop-down list select BEARER (set the MechanismName property to BEARER). For more information, see the Installation and Configuration Guide. * [SENTDO-2798] OIDC Device Authorization Grant authentication You can now authenticate your connection with OIDC Device Authorization Grant, also known as OIDC Device Flow. To do this, from the Mechanism drop-down list select CODE (set the MechanismName property to CODE). For more information, see the Installation and Configuration Guide. Resolved Issues The following issues have been resolved in Simba Teradata ODBC Connector 20.00.00.008. * [SENTDO-2813] When the client ID or scope value contains a space and it is not URL encoded, the connector truncates the value. * [SENTDO-2814] In some cases, when connecting to the Teradata database using SSLMode Prefer or Allow, the connector connects to an incorrect port. * [SENTDO-2844] When retrieving BIG5 characters (two bytes each) from a character set LATIN table's VARCHAR column that has odd number of bytes (e.g. VARCHAR(25)), the first character of the next row is corrupted. 20.00.00.006 ----------------------------------------------------------------- Released 2024-02-23 Resolved Issues The following issue has been resolved in Simba Teradata ODBC Connector 20.00.00.006. * [SENTDO-2751] When a table contains a CLOB column size greater than 2,097,088,000 bytes, .NET System.Data.Odbc.OdbcDataReader.GetSchemaTable() returns arithmetic overflow exception. 20.00.00.005 ----------------------------------------------------------------- Released 2024-01-25 Resolved Issues The following issue has been resolved in Simba Teradata ODBC Connector 20.00.00.005. * [SENTDO-2751] When a table contains a CLOB column size greater than 2,097,088,000 bytes, .NET System.Data.Odbc.OdbcDataReader.GetSchemaTable() returns arithmetic overflow exception. ==============================================================================